Overview
Brought to you by YData
Dataset statistics
| Number of variables | 22 |
|---|---|
| Number of observations | 7319 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 1.3 MiB |
| Average record size in memory | 184.0 B |
Variable types
| Text | 8 |
|---|---|
| Numeric | 6 |
| Categorical | 8 |
loves_count is highly overall correlated with reviews | High correlation |
primary_category is highly overall correlated with secondary_category | High correlation |
reviews is highly overall correlated with loves_count | High correlation |
secondary_category is highly overall correlated with primary_category and 1 other fields | High correlation |
variation_type is highly overall correlated with secondary_category | High correlation |
limited_edition is highly imbalanced (67.8%) | Imbalance |
new is highly imbalanced (67.2%) | Imbalance |
out_of_stock is highly imbalanced (64.0%) | Imbalance |
product_id has unique values | Unique |
child_count has 4758 (65.0%) zeros | Zeros |
Reproduction
| Analysis started | 2025-10-08 02:53:07.973300 |
|---|---|
| Analysis finished | 2025-10-08 02:53:16.980851 |
| Duration | 9.01 seconds |
| Software version | ydata-profiling vv4.17.0 |
| Download configuration | config.json |
Variables
product_id
Text
Unique
| Distinct | 7319 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 114.4 KiB |
Length
| Max length | 11 |
|---|---|
| Median length | 7 |
| Mean length | 6.9946714 |
| Min length | 5 |
Unique
| Unique | 7319 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | P473671 |
|---|---|
| 2nd row | P473668 |
| 3rd row | P473662 |
| 4th row | P473660 |
| 5th row | P473658 |
| Value | Count | Frequency (%) |
| p473666 | 1 | < 0.1% |
| p504428 | 1 | < 0.1% |
| p473671 | 1 | < 0.1% |
| p473668 | 1 | < 0.1% |
| p473662 | 1 | < 0.1% |
| p473660 | 1 | < 0.1% |
| p473658 | 1 | < 0.1% |
| p504075 | 1 | < 0.1% |
| p471294 | 1 | < 0.1% |
| p432087 | 1 | < 0.1% |
| Other values (7309) | 7309 |
Most occurring characters
| Value | Count | Frequency (%) |
| 4 | 8843 | |
| P | 7319 | |
| 0 | 4899 | |
| 5 | 4723 | |
| 3 | 3987 | |
| 7 | 3921 | |
| 2 | 3879 | |
| 1 | 3872 | |
| 6 | 3473 | 6.8% |
| 8 | 3353 | 6.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 51194 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 4 | 8843 | |
| P | 7319 | |
| 0 | 4899 | |
| 5 | 4723 | |
| 3 | 3987 | |
| 7 | 3921 | |
| 2 | 3879 | |
| 1 | 3872 | |
| 6 | 3473 | 6.8% |
| 8 | 3353 | 6.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 51194 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 4 | 8843 | |
| P | 7319 | |
| 0 | 4899 | |
| 5 | 4723 | |
| 3 | 3987 | |
| 7 | 3921 | |
| 2 | 3879 | |
| 1 | 3872 | |
| 6 | 3473 | 6.8% |
| 8 | 3353 | 6.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 51194 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 4 | 8843 | |
| P | 7319 | |
| 0 | 4899 | |
| 5 | 4723 | |
| 3 | 3987 | |
| 7 | 3921 | |
| 2 | 3879 | |
| 1 | 3872 | |
| 6 | 3473 | 6.8% |
| 8 | 3353 | 6.5% |
product_name
Text
| Distinct | 7270 |
|---|---|
| Distinct (%) | 99.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 114.4 KiB |
Length
| Max length | 107 |
|---|---|
| Median length | 76 |
| Mean length | 35.862413 |
| Min length | 3 |
Unique
| Unique | 7225 ? |
|---|---|
| Unique (%) | 98.7% |
Sample
| 1st row | Fragrance Discovery Set |
|---|---|
| 2nd row | La Habana Eau de Parfum |
| 3rd row | Rainbow Bar Eau de Parfum |
| 4th row | Kasbah Eau de Parfum |
| 5th row | Purple Haze Eau de Parfum |
| Value | Count | Frequency (%) |
| 1174 | 2.9% | |
| mini | 769 | 1.9% |
| de | 576 | 1.4% |
| eau | 558 | 1.4% |
| hair | 558 | 1.4% |
| cream | 553 | 1.4% |
| serum | 459 | 1.1% |
| parfum | 445 | 1.1% |
| spray | 419 | 1.0% |
| with | 391 | 1.0% |
| Other values (4244) | 34126 |
Most occurring characters
| Value | Count | Frequency (%) |
| 32770 | 12.5% | |
| e | 22502 | 8.6% |
| i | 19772 | 7.5% |
| a | 16163 | 6.2% |
| r | 16028 | 6.1% |
| n | 14296 | 5.4% |
| o | 12967 | 4.9% |
| t | 12289 | 4.7% |
| l | 10692 | 4.1% |
| u | 7199 | 2.7% |
| Other values (100) | 97799 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 262477 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 32770 | 12.5% | |
| e | 22502 | 8.6% |
| i | 19772 | 7.5% |
| a | 16163 | 6.2% |
| r | 16028 | 6.1% |
| n | 14296 | 5.4% |
| o | 12967 | 4.9% |
| t | 12289 | 4.7% |
| l | 10692 | 4.1% |
| u | 7199 | 2.7% |
| Other values (100) | 97799 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 262477 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 32770 | 12.5% | |
| e | 22502 | 8.6% |
| i | 19772 | 7.5% |
| a | 16163 | 6.2% |
| r | 16028 | 6.1% |
| n | 14296 | 5.4% |
| o | 12967 | 4.9% |
| t | 12289 | 4.7% |
| l | 10692 | 4.1% |
| u | 7199 | 2.7% |
| Other values (100) | 97799 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 262477 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 32770 | 12.5% | |
| e | 22502 | 8.6% |
| i | 19772 | 7.5% |
| a | 16163 | 6.2% |
| r | 16028 | 6.1% |
| n | 14296 | 5.4% |
| o | 12967 | 4.9% |
| t | 12289 | 4.7% |
| l | 10692 | 4.1% |
| u | 7199 | 2.7% |
| Other values (100) | 97799 |
brand_id
Real number (ℝ)
| Distinct | 282 |
|---|---|
| Distinct (%) | 3.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5398.4909 |
| Minimum | 1063 |
|---|---|
| Maximum | 8020 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 114.4 KiB |
Quantile statistics
| Minimum | 1063 |
|---|---|
| 5-th percentile | 1138 |
| Q1 | 5333 |
| median | 6159 |
| Q3 | 6325 |
| 95-th percentile | 7065 |
| Maximum | 8020 |
| Range | 6957 |
| Interquartile range (IQR) | 992 |
Descriptive statistics
| Standard deviation | 1741.6493 |
|---|---|
| Coefficient of variation (CV) | 0.3226178 |
| Kurtosis | 0.97689759 |
| Mean | 5398.4909 |
| Median Absolute Deviation (MAD) | 280 |
| Skewness | -1.4361774 |
| Sum | 39511555 |
| Variance | 3033342.2 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3902 | 203 | 2.8% |
| 1254 | 175 | 2.4% |
| 1073 | 122 | 1.7% |
| 5648 | 115 | 1.6% |
| 6259 | 107 | 1.5% |
| 5995 | 105 | 1.4% |
| 5869 | 96 | 1.3% |
| 6236 | 93 | 1.3% |
| 6346 | 84 | 1.1% |
| 6182 | 81 | 1.1% |
| Other values (272) | 6138 |
| Value | Count | Frequency (%) |
| 1063 | 51 | |
| 1065 | 42 | 0.6% |
| 1070 | 57 | |
| 1071 | 13 | 0.2% |
| 1073 | 122 | |
| 1132 | 38 | 0.5% |
| 1133 | 36 | 0.5% |
| 1138 | 8 | 0.1% |
| 1164 | 9 | 0.1% |
| 1169 | 29 | 0.4% |
| Value | Count | Frequency (%) |
| 8020 | 12 | 0.2% |
| 8017 | 40 | |
| 8012 | 11 | 0.2% |
| 8008 | 17 | |
| 8007 | 36 | |
| 8001 | 28 | |
| 8000 | 5 | 0.1% |
| 7103 | 9 | 0.1% |
| 7102 | 1 | < 0.1% |
| 7101 | 27 |
brand_name
Text
| Distinct | 282 |
|---|---|
| Distinct (%) | 3.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 114.4 KiB |
Length
| Max length | 33 |
|---|---|
| Median length | 22 |
| Mean length | 11.122421 |
| Min length | 3 |
Unique
| Unique | 9 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | 19-69 |
|---|---|
| 2nd row | 19-69 |
| 3rd row | 19-69 |
| 4th row | 19-69 |
| 5th row | 19-69 |
| Value | Count | Frequency (%) |
| beauty | 427 | 3.3% |
| by | 238 | 1.8% |
| bumble | 210 | 1.6% |
| sephora | 205 | 1.6% |
| collection | 203 | 1.5% |
| the | 180 | 1.4% |
| clinique | 175 | 1.3% |
| dr | 165 | 1.3% |
| cosmetics | 160 | 1.2% |
| skincare | 128 | 1.0% |
| Other values (418) | 11008 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 5818 | 7.1% |
| a | 5816 | 7.1% |
| 5780 | 7.1% | |
| r | 4542 | 5.6% |
| i | 4101 | 5.0% |
| o | 3774 | 4.6% |
| n | 3026 | 3.7% |
| s | 2978 | 3.7% |
| t | 2909 | 3.6% |
| l | 2496 | 3.1% |
| Other values (61) | 40165 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 81405 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 5818 | 7.1% |
| a | 5816 | 7.1% |
| 5780 | 7.1% | |
| r | 4542 | 5.6% |
| i | 4101 | 5.0% |
| o | 3774 | 4.6% |
| n | 3026 | 3.7% |
| s | 2978 | 3.7% |
| t | 2909 | 3.6% |
| l | 2496 | 3.1% |
| Other values (61) | 40165 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 81405 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 5818 | 7.1% |
| a | 5816 | 7.1% |
| 5780 | 7.1% | |
| r | 4542 | 5.6% |
| i | 4101 | 5.0% |
| o | 3774 | 4.6% |
| n | 3026 | 3.7% |
| s | 2978 | 3.7% |
| t | 2909 | 3.6% |
| l | 2496 | 3.1% |
| Other values (61) | 40165 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 81405 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 5818 | 7.1% |
| a | 5816 | 7.1% |
| 5780 | 7.1% | |
| r | 4542 | 5.6% |
| i | 4101 | 5.0% |
| o | 3774 | 4.6% |
| n | 3026 | 3.7% |
| s | 2978 | 3.7% |
| t | 2909 | 3.6% |
| l | 2496 | 3.1% |
| Other values (61) | 40165 |
loves_count
Real number (ℝ)
High correlation
| Distinct | 6598 |
|---|---|
| Distinct (%) | 90.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 31486.218 |
| Minimum | 0 |
|---|---|
| Maximum | 1401068 |
| Zeros | 36 |
| Zeros (%) | 0.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 114.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1039 |
| Q1 | 4285 |
| median | 10852 |
| Q3 | 29036.5 |
| 95-th percentile | 122030.1 |
| Maximum | 1401068 |
| Range | 1401068 |
| Interquartile range (IQR) | 24751.5 |
Descriptive statistics
| Standard deviation | 68973.452 |
|---|---|
| Coefficient of variation (CV) | 2.1905919 |
| Kurtosis | 74.850831 |
| Mean | 31486.218 |
| Median Absolute Deviation (MAD) | 8318 |
| Skewness | 6.8991738 |
| Sum | 2.3044763 × 108 |
| Variance | 4.757337 × 109 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 36 | 0.5% |
| 1039 | 4 | 0.1% |
| 1177 | 4 | 0.1% |
| 1333 | 4 | 0.1% |
| 4403 | 4 | 0.1% |
| 435 | 4 | 0.1% |
| 1695 | 4 | 0.1% |
| 4679 | 4 | 0.1% |
| 3226 | 4 | 0.1% |
| 10153 | 3 | < 0.1% |
| Other values (6588) | 7248 |
| Value | Count | Frequency (%) |
| 0 | 36 | |
| 10 | 1 | < 0.1% |
| 13 | 1 | < 0.1% |
| 17 | 1 | < 0.1% |
| 23 | 2 | < 0.1% |
| 27 | 1 | < 0.1% |
| 43 | 1 | < 0.1% |
| 48 | 1 | < 0.1% |
| 67 | 1 | < 0.1% |
| 96 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1401068 | 1 | |
| 1153594 | 1 | |
| 1081315 | 1 | |
| 1029051 | 1 | |
| 968317 | 1 | |
| 856497 | 1 | |
| 840076 | 1 | |
| 813497 | 1 | |
| 763168 | 1 | |
| 720504 | 1 |
rating
Real number (ℝ)
| Distinct | 4107 |
|---|---|
| Distinct (%) | 56.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.1990454 |
| Minimum | 1 |
|---|---|
| Maximum | 5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 114.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3.29049 |
| Q1 | 3.99605 |
| median | 4.2888 |
| Q3 | 4.5245 |
| 95-th percentile | 4.82681 |
| Maximum | 5 |
| Range | 4 |
| Interquartile range (IQR) | 0.52845 |
Descriptive statistics
| Standard deviation | 0.49587245 |
|---|---|
| Coefficient of variation (CV) | 0.11809171 |
| Kurtosis | 4.2485414 |
| Mean | 4.1990454 |
| Median Absolute Deviation (MAD) | 0.2668 |
| Skewness | -1.4905891 |
| Sum | 30732.813 |
| Variance | 0.24588948 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5 | 202 | 2.8% |
| 4 | 149 | 2.0% |
| 4.5 | 70 | 1.0% |
| 4.3333 | 58 | 0.8% |
| 3 | 55 | 0.8% |
| 3.5 | 54 | 0.7% |
| 4.6667 | 53 | 0.7% |
| 4.25 | 36 | 0.5% |
| 4.2 | 35 | 0.5% |
| 3.6667 | 32 | 0.4% |
| Other values (4097) | 6575 |
| Value | Count | Frequency (%) |
| 1 | 7 | |
| 1.1905 | 1 | < 0.1% |
| 1.25 | 1 | < 0.1% |
| 1.3333 | 1 | < 0.1% |
| 1.5 | 1 | < 0.1% |
| 1.6667 | 1 | < 0.1% |
| 1.75 | 1 | < 0.1% |
| 1.7727 | 1 | < 0.1% |
| 1.8 | 3 | |
| 1.8333 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 5 | 202 | |
| 4.9937 | 1 | < 0.1% |
| 4.9825 | 1 | < 0.1% |
| 4.9722 | 1 | < 0.1% |
| 4.9643 | 1 | < 0.1% |
| 4.9623 | 2 | < 0.1% |
| 4.9545 | 1 | < 0.1% |
| 4.9518 | 1 | < 0.1% |
| 4.9487 | 2 | < 0.1% |
| 4.9474 | 2 | < 0.1% |
reviews
Real number (ℝ)
High correlation
| Distinct | 1522 |
|---|---|
| Distinct (%) | 20.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 477.7695 |
| Minimum | 1 |
|---|---|
| Maximum | 21281 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 114.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 31 |
| median | 144 |
| Q3 | 453 |
| 95-th percentile | 1966 |
| Maximum | 21281 |
| Range | 21280 |
| Interquartile range (IQR) | 422 |
Descriptive statistics
| Standard deviation | 1124.1344 |
|---|---|
| Coefficient of variation (CV) | 2.3528803 |
| Kurtosis | 85.172526 |
| Mean | 477.7695 |
| Median Absolute Deviation (MAD) | 131 |
| Skewness | 7.5271151 |
| Sum | 3496795 |
| Variance | 1263678.2 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4 | 118 | 1.6% |
| 2 | 117 | 1.6% |
| 3 | 100 | 1.4% |
| 6 | 99 | 1.4% |
| 1 | 99 | 1.4% |
| 5 | 95 | 1.3% |
| 8 | 79 | 1.1% |
| 10 | 76 | 1.0% |
| 9 | 73 | 1.0% |
| 7 | 69 | 0.9% |
| Other values (1512) | 6394 |
| Value | Count | Frequency (%) |
| 1 | 99 | |
| 2 | 117 | |
| 3 | 100 | |
| 4 | 118 | |
| 5 | 95 | |
| 6 | 99 | |
| 7 | 69 | |
| 8 | 79 | |
| 9 | 73 | |
| 10 | 76 |
| Value | Count | Frequency (%) |
| 21281 | 1 | |
| 18610 | 1 | |
| 18127 | 1 | |
| 17179 | 1 | |
| 16935 | 1 | |
| 16118 | 1 | |
| 15756 | 1 | |
| 14882 | 1 | |
| 14468 | 1 | |
| 12887 | 1 |
size
Text
| Distinct | 1927 |
|---|---|
| Distinct (%) | 26.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 114.4 KiB |
Length
| Max length | 65 |
|---|---|
| Median length | 59 |
| Mean length | 12.738762 |
| Min length | 3 |
Unique
| Unique | 1313 ? |
|---|---|
| Unique (%) | 17.9% |
Sample
| 1st row | Unknown |
|---|---|
| 2nd row | 3.4 oz/ 100 mL |
| 3rd row | 3.4 oz/ 100 mL |
| 4th row | 3.4 oz/ 100 mL |
| 5th row | 3.4 oz/ 100 mL |
| Value | Count | Frequency (%) |
| oz | 6092 | |
| ml | 4774 | |
| 1524 | 5.5% | |
| g | 1067 | 3.8% |
| unknown | 911 | 3.3% |
| 50 | 776 | 2.8% |
| 1.7 | 670 | 2.4% |
| 30 | 637 | 2.3% |
| 1 | 618 | 2.2% |
| 100 | 391 | 1.4% |
| Other values (981) | 10282 |
Most occurring characters
| Value | Count | Frequency (%) |
| 20451 | ||
| o | 7200 | 7.7% |
| 0 | 7048 | 7.6% |
| z | 6240 | 6.7% |
| / | 6050 | 6.5% |
| . | 5724 | 6.1% |
| m | 4971 | 5.3% |
| 1 | 4766 | 5.1% |
| L | 4710 | 5.1% |
| 5 | 3794 | 4.1% |
| Other values (63) | 22281 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 93235 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 20451 | ||
| o | 7200 | 7.7% |
| 0 | 7048 | 7.6% |
| z | 6240 | 6.7% |
| / | 6050 | 6.5% |
| . | 5724 | 6.1% |
| m | 4971 | 5.3% |
| 1 | 4766 | 5.1% |
| L | 4710 | 5.1% |
| 5 | 3794 | 4.1% |
| Other values (63) | 22281 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 93235 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 20451 | ||
| o | 7200 | 7.7% |
| 0 | 7048 | 7.6% |
| z | 6240 | 6.7% |
| / | 6050 | 6.5% |
| . | 5724 | 6.1% |
| m | 4971 | 5.3% |
| 1 | 4766 | 5.1% |
| L | 4710 | 5.1% |
| 5 | 3794 | 4.1% |
| Other values (63) | 22281 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 93235 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 20451 | ||
| o | 7200 | 7.7% |
| 0 | 7048 | 7.6% |
| z | 6240 | 6.7% |
| / | 6050 | 6.5% |
| . | 5724 | 6.1% |
| m | 4971 | 5.3% |
| 1 | 4766 | 5.1% |
| L | 4710 | 5.1% |
| 5 | 3794 | 4.1% |
| Other values (63) | 22281 |
variation_type
Categorical
High correlation
| Distinct | 8 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 114.4 KiB |
| Size | |
|---|---|
| Color | |
| Size + Concentration + Formulation | |
| Not Applicable | |
| Type | 64 |
| Other values (3) | 41 |
Length
| Max length | 34 |
|---|---|
| Median length | 4 |
| Mean length | 9.5295805 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Not Applicable |
|---|---|
| 2nd row | Size + Concentration + Formulation |
| 3rd row | Size + Concentration + Formulation |
| 4th row | Size + Concentration + Formulation |
| 5th row | Size + Concentration + Formulation |
Common Values
| Value | Count | Frequency (%) |
| Size | 3824 | |
| Color | 1553 | |
| Size + Concentration + Formulation | 1018 | 13.9% |
| Not Applicable | 819 | 11.2% |
| Type | 64 | 0.9% |
| Scent | 30 | 0.4% |
| Size + Concentration | 9 | 0.1% |
| Formulation | 2 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| size | 4851 | |
| 2045 | ||
| color | 1553 | 12.7% |
| concentration | 1027 | 8.4% |
| formulation | 1020 | 8.3% |
| not | 819 | 6.7% |
| applicable | 819 | 6.7% |
| type | 64 | 0.5% |
| scent | 30 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 8019 | |
| i | 7717 | |
| e | 6791 | |
| 4909 | 7.0% | |
| S | 4881 | 7.0% |
| z | 4851 | 7.0% |
| l | 4211 | 6.0% |
| n | 4131 | 5.9% |
| t | 3923 | 5.6% |
| r | 3600 | 5.2% |
| Other values (13) | 16714 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 69747 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| o | 8019 | |
| i | 7717 | |
| e | 6791 | |
| 4909 | 7.0% | |
| S | 4881 | 7.0% |
| z | 4851 | 7.0% |
| l | 4211 | 6.0% |
| n | 4131 | 5.9% |
| t | 3923 | 5.6% |
| r | 3600 | 5.2% |
| Other values (13) | 16714 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 69747 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| o | 8019 | |
| i | 7717 | |
| e | 6791 | |
| 4909 | 7.0% | |
| S | 4881 | 7.0% |
| z | 4851 | 7.0% |
| l | 4211 | 6.0% |
| n | 4131 | 5.9% |
| t | 3923 | 5.6% |
| r | 3600 | 5.2% |
| Other values (13) | 16714 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 69747 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| o | 8019 | |
| i | 7717 | |
| e | 6791 | |
| 4909 | 7.0% | |
| S | 4881 | 7.0% |
| z | 4851 | 7.0% |
| l | 4211 | 6.0% |
| n | 4131 | 5.9% |
| t | 3923 | 5.6% |
| r | 3600 | 5.2% |
| Other values (13) | 16714 |
variation_value
Text
| Distinct | 2525 |
|---|---|
| Distinct (%) | 34.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 114.4 KiB |
Length
| Max length | 82 |
|---|---|
| Median length | 70 |
| Mean length | 13.600902 |
| Min length | 1 |
Unique
| Unique | 1914 ? |
|---|---|
| Unique (%) | 26.2% |
Sample
| 1st row | Unknown |
|---|---|
| 2nd row | 3.4 oz/ 100 mL |
| 3rd row | 3.4 oz/ 100 mL |
| 4th row | 3.4 oz/ 100 mL |
| 5th row | 3.4 oz/ 100 mL |
| Value | Count | Frequency (%) |
| oz | 4589 | 17.5% |
| ml | 4049 | 15.4% |
| 1134 | 4.3% | |
| unknown | 935 | 3.6% |
| 50 | 747 | 2.8% |
| 1.7 | 645 | 2.5% |
| 1 | 529 | 2.0% |
| spray | 517 | 2.0% |
| 30 | 511 | 1.9% |
| de | 486 | 1.9% |
| Other values (1842) | 12082 |
Most occurring characters
| Value | Count | Frequency (%) |
| 18997 | ||
| o | 6659 | 6.7% |
| 0 | 5163 | 5.2% |
| m | 4914 | 4.9% |
| z | 4764 | 4.8% |
| / | 4587 | 4.6% |
| L | 4162 | 4.2% |
| 1 | 3817 | 3.8% |
| n | 3795 | 3.8% |
| . | 3689 | 3.7% |
| Other values (76) | 38998 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 99545 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 18997 | ||
| o | 6659 | 6.7% |
| 0 | 5163 | 5.2% |
| m | 4914 | 4.9% |
| z | 4764 | 4.8% |
| / | 4587 | 4.6% |
| L | 4162 | 4.2% |
| 1 | 3817 | 3.8% |
| n | 3795 | 3.8% |
| . | 3689 | 3.7% |
| Other values (76) | 38998 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 99545 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 18997 | ||
| o | 6659 | 6.7% |
| 0 | 5163 | 5.2% |
| m | 4914 | 4.9% |
| z | 4764 | 4.8% |
| / | 4587 | 4.6% |
| L | 4162 | 4.2% |
| 1 | 3817 | 3.8% |
| n | 3795 | 3.8% |
| . | 3689 | 3.7% |
| Other values (76) | 38998 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 99545 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 18997 | ||
| o | 6659 | 6.7% |
| 0 | 5163 | 5.2% |
| m | 4914 | 4.9% |
| z | 4764 | 4.8% |
| / | 4587 | 4.6% |
| L | 4162 | 4.2% |
| 1 | 3817 | 3.8% |
| n | 3795 | 3.8% |
| . | 3689 | 3.7% |
| Other values (76) | 38998 |
ingredients
Text
| Distinct | 6396 |
|---|---|
| Distinct (%) | 87.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 114.4 KiB |
Length
| Max length | 16488 |
|---|---|
| Median length | 1689 |
| Mean length | 768.10452 |
| Min length | 16 |
Unique
| Unique | 5569 ? |
|---|---|
| Unique (%) | 76.1% |
Sample
| 1st row | ['Capri Eau de Parfum:', 'Alcohol Denat. (SD Alcohol 39C), Parfum (Fragrance) D-Limonene, Linalool, Benzyl Salicylate, Ethylhexyl Methoxycinnamate, Butyl Methoxydibenzoylmethane, Ethylhexyl Salicylate, Benzl Benzoate, Citral, Geraniol, Eugenol, Benzyl Alcohol, Farnesol, Citronellol, Isoeugenol.', 'Invisible Post Eau de Parfum:', 'Alcohol Denat. (SD Alcohol 39C), Parfum (Fragrance) Ethylhexyl Methoxycinnamate, Ethylhexyl Salicylate, Butyl Methoxydibenzoylmethane, Benzyl Benzoate, Citral, Coumarin, Limonene, Alpha-Isomethyl Ionone, Linalool.', 'Kashbah Eau de Parfum:', 'Alcohol Denat. (SD Alcohol 39C), Parfum (Fragrance) Coumarin, Ethylhexyl Methoxycinnamate, Butyl Methoxydibenzoylmethane, Ethylhexyl Salicylate, D-Limonene, Eugenol, Linalool, Citronellol, Geraniol, Cinnamal, Citral.', 'L’Air Barbes Eau de Parfum:', 'Alcohol Denat. (SD Alcohol 39C), Parfum (Fragrance) Benzyl Salicylate, D-Limonene, Ethylhexyl Methoxycinnamate, Butyl Methoxydibenzoylmethane, Ethylhexyl Salicylate, Linalool Citral, Alphaisomethyl Ionone, Benzyl Benzoate, Geraniol Farnesol, Isoeugenol, Eugenol.', 'La Habana Eau de Parfum:', 'Alcohol Denat. (SD Alcohol 39C), Parfum (Fragrance) Ethylhexyl Methoxycinnamate, Ethylhexyl Salicylate, Butyl Methoxydibenzoylmethane, Benzyl Alcohol, Benzyl Benzoate, Benzyl Cinnamate, Cinnamal, Citral, Coumarin Limonene, Eugenol, Alpha-Isomethyl Ionone, Linalool.', 'Purple Haze Eau de Parfum:', 'Alcohol Denat. (SD Alcohol 39C), Parfum (Fragrance) Octoxynol-10, D-Limonene, Ethylhexyl Methoxycinnamate, Butyl Methoxydibenzoylmethane, Ethylhexyl Salicylate, Geraniol, Linalool, Coumarin, Farnesol, Eugenol, Citral.', 'Rainbow Bar Eau de Parfum:', 'Alcohol Denat. (SD Alcohol 39C), Parfum (Fragrance) D-Limonene, Ethylhexyl Methoxycinnamate, Butyl Methoxydibenzoylmethane, Ethylhexyl Salicylate, Hexyl Cinnamal, Citronellol, Linalool, Coumarin, Eugenol, Citral, Isoeugenol, Geraniol.'] |
|---|---|
| 2nd row | ['Alcohol Denat. (SD Alcohol 39C), Parfum (Fragrance) Ethylhexyl Methoxycinnamate, Ethylhexyl Salicylate, Butyl Methoxydibenzoylmethane, Benzyl Alcohol, Benzyl Benzoate, Benzyl Cinnamate, Cinnamal, Citral, Coumarin Limonene, Eugenol, Alpha-Isomethyl Ionone, Linalool.'] |
| 3rd row | ['Alcohol Denat. (SD Alcohol 39C), Parfum (Fragrance) D-Limonene, Ethylhexyl Methoxycinnamate, Butyl Methoxydibenzoylmethane, Ethylhexyl Salicylate, Hexyl Cinnamal Citronellol, Linalool, Coumarin, Eugenol, Citral, Isoeugenol, Geraniol.'] |
| 4th row | ['Alcohol Denat. (SD Alcohol 39C), Parfum (Fragrance) Coumarin, Ethylhexyl Methoxycinnamate, Butyl Methoxydibenzoylmethane, Ethylhexyl Salicylate, D-Limonene, Eugenol, Linalool, Citronellol, Geraniol, Cinnamal, Citral.'] |
| 5th row | ['Alcohol Denat. (SD Alcohol 39C), Parfum (Fragrance) Octoxynol-10, D-Limonene, Ethylhexyl Methoxycinnamate, Butyl Methoxydibenzoylmethane, Ethylhexyl Salicylate, Geraniol, Linalool, Coumarin, Farnesol, Eugenol, Citral.'] |
| Value | Count | Frequency (%) |
| extract | 19497 | 3.2% |
| ci | 18977 | 3.2% |
| oil | 13258 | 2.2% |
| sodium | 12256 | 2.0% |
| acid | 9605 | 1.6% |
| glycol | 8529 | 1.4% |
| alcohol | 7747 | 1.3% |
| seed | 7645 | 1.3% |
| 4712 | 0.8% | |
| fruit | 4591 | 0.8% |
| Other values (11591) | 495626 |
Most occurring characters
| Value | Count | Frequency (%) |
| 596642 | 10.6% | |
| e | 436707 | 7.8% |
| a | 361920 | 6.4% |
| i | 347715 | 6.2% |
| l | 323344 | 5.8% |
| o | 303573 | 5.4% |
| t | 287614 | 5.1% |
| r | 275556 | 4.9% |
| , | 249663 | 4.4% |
| n | 228004 | 4.1% |
| Other values (114) | 2211019 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 5621757 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 596642 | 10.6% | |
| e | 436707 | 7.8% |
| a | 361920 | 6.4% |
| i | 347715 | 6.2% |
| l | 323344 | 5.8% |
| o | 303573 | 5.4% |
| t | 287614 | 5.1% |
| r | 275556 | 4.9% |
| , | 249663 | 4.4% |
| n | 228004 | 4.1% |
| Other values (114) | 2211019 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 5621757 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 596642 | 10.6% | |
| e | 436707 | 7.8% |
| a | 361920 | 6.4% |
| i | 347715 | 6.2% |
| l | 323344 | 5.8% |
| o | 303573 | 5.4% |
| t | 287614 | 5.1% |
| r | 275556 | 4.9% |
| , | 249663 | 4.4% |
| n | 228004 | 4.1% |
| Other values (114) | 2211019 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 5621757 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 596642 | 10.6% | |
| e | 436707 | 7.8% |
| a | 361920 | 6.4% |
| i | 347715 | 6.2% |
| l | 323344 | 5.8% |
| o | 303573 | 5.4% |
| t | 287614 | 5.1% |
| r | 275556 | 4.9% |
| , | 249663 | 4.4% |
| n | 228004 | 4.1% |
| Other values (114) | 2211019 |
price_usd
Real number (ℝ)
| Distinct | 273 |
|---|---|
| Distinct (%) | 3.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 50.518228 |
| Minimum | 3 |
|---|---|
| Maximum | 449 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 114.4 KiB |
Quantile statistics
| Minimum | 3 |
|---|---|
| 5-th percentile | 14 |
| Q1 | 25 |
| median | 35 |
| Q3 | 58 |
| 95-th percentile | 140 |
| Maximum | 449 |
| Range | 446 |
| Interquartile range (IQR) | 33 |
Descriptive statistics
| Standard deviation | 47.672479 |
|---|---|
| Coefficient of variation (CV) | 0.94366887 |
| Kurtosis | 15.90191 |
| Mean | 50.518228 |
| Median Absolute Deviation (MAD) | 13 |
| Skewness | 3.3633906 |
| Sum | 369742.91 |
| Variance | 2272.6653 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 30 | 297 | 4.1% |
| 32 | 278 | 3.8% |
| 25 | 259 | 3.5% |
| 28 | 242 | 3.3% |
| 20 | 229 | 3.1% |
| 38 | 222 | 3.0% |
| 26 | 222 | 3.0% |
| 24 | 186 | 2.5% |
| 29 | 180 | 2.5% |
| 35 | 179 | 2.4% |
| Other values (263) | 5025 |
| Value | Count | Frequency (%) |
| 3 | 5 | 0.1% |
| 3.5 | 3 | < 0.1% |
| 4.5 | 1 | < 0.1% |
| 5 | 14 | |
| 5.5 | 5 | 0.1% |
| 5.99 | 2 | < 0.1% |
| 6 | 8 | |
| 6.4 | 2 | < 0.1% |
| 6.5 | 4 | 0.1% |
| 6.7 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 449 | 2 | < 0.1% |
| 429 | 2 | < 0.1% |
| 425 | 1 | < 0.1% |
| 410 | 1 | < 0.1% |
| 400 | 1 | < 0.1% |
| 399 | 3 | < 0.1% |
| 395 | 9 | |
| 390 | 3 | < 0.1% |
| 380 | 3 | < 0.1% |
| 370 | 1 | < 0.1% |
limited_edition
Categorical
Imbalance
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 114.4 KiB |
| 0 | |
|---|---|
| 1 | 429 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 6890 | |
| 1 | 429 | 5.9% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 6890 | |
| 1 | 429 | 5.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 6890 | |
| 1 | 429 | 5.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7319 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 6890 | |
| 1 | 429 | 5.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7319 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 6890 | |
| 1 | 429 | 5.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7319 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 6890 | |
| 1 | 429 | 5.9% |
new
Categorical
Imbalance
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 114.4 KiB |
| 0 | |
|---|---|
| 1 | 440 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 6879 | |
| 1 | 440 | 6.0% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 6879 | |
| 1 | 440 | 6.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 6879 | |
| 1 | 440 | 6.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7319 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 6879 | |
| 1 | 440 | 6.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7319 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 6879 | |
| 1 | 440 | 6.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7319 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 6879 | |
| 1 | 440 | 6.0% |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 5845 | |
| 1 | 1474 | 20.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 5845 | |
| 1 | 1474 | 20.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 5845 | |
| 1 | 1474 | 20.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7319 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 5845 | |
| 1 | 1474 | 20.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7319 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 5845 | |
| 1 | 1474 | 20.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7319 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 5845 | |
| 1 | 1474 | 20.1% |
out_of_stock
Categorical
Imbalance
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 114.4 KiB |
| 0 | |
|---|---|
| 1 | 500 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 6819 | |
| 1 | 500 | 6.8% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 6819 | |
| 1 | 500 | 6.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 6819 | |
| 1 | 500 | 6.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7319 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 6819 | |
| 1 | 500 | 6.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7319 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 6819 | |
| 1 | 500 | 6.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7319 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 6819 | |
| 1 | 500 | 6.8% |
sephora_exclusive
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 114.4 KiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 5305 | |
| 1 | 2014 | 27.5% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 5305 | |
| 1 | 2014 | 27.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 5305 | |
| 1 | 2014 | 27.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7319 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 5305 | |
| 1 | 2014 | 27.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7319 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 5305 | |
| 1 | 2014 | 27.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7319 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 5305 | |
| 1 | 2014 | 27.5% |
highlights
Text
| Distinct | 4112 |
|---|---|
| Distinct (%) | 56.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 114.4 KiB |
Length
| Max length | 192 |
|---|---|
| Median length | 157 |
| Mean length | 77.646536 |
| Min length | 9 |
Unique
| Unique | 3326 ? |
|---|---|
| Unique (%) | 45.4% |
Sample
| 1st row | ['Unisex/ Genderless Scent', 'Warm &Spicy Scent', 'Woody & Earthy Scent', 'Fresh Scent'] |
|---|---|
| 2nd row | ['Unisex/ Genderless Scent', 'Layerable Scent', 'Warm &Spicy Scent'] |
| 3rd row | ['Unisex/ Genderless Scent', 'Layerable Scent', 'Woody & Earthy Scent'] |
| 4th row | ['Unisex/ Genderless Scent', 'Layerable Scent', 'Warm &Spicy Scent'] |
| 5th row | ['Unisex/ Genderless Scent', 'Layerable Scent', 'Woody & Earthy Scent'] |
| Value | Count | Frequency (%) |
| for | 6460 | 9.1% |
| good | 5435 | 7.6% |
| without | 3014 | 4.2% |
| vegan | 2364 | 3.3% |
| clean | 2109 | 3.0% |
| highlights | 1700 | 2.4% |
| no | 1700 | 2.4% |
| cruelty-free | 1574 | 2.2% |
| at | 1534 | 2.2% |
| sephora | 1534 | 2.2% |
| Other values (145) | 43671 |
Most occurring characters
| Value | Count | Frequency (%) |
| 63776 | 11.2% | |
| ' | 54893 | 9.7% |
| e | 38941 | 6.9% |
| o | 35016 | 6.2% |
| r | 29810 | 5.2% |
| a | 27114 | 4.8% |
| i | 26676 | 4.7% |
| n | 25652 | 4.5% |
| t | 23638 | 4.2% |
| , | 23469 | 4.1% |
| Other values (52) | 219310 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 568295 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 63776 | 11.2% | |
| ' | 54893 | 9.7% |
| e | 38941 | 6.9% |
| o | 35016 | 6.2% |
| r | 29810 | 5.2% |
| a | 27114 | 4.8% |
| i | 26676 | 4.7% |
| n | 25652 | 4.5% |
| t | 23638 | 4.2% |
| , | 23469 | 4.1% |
| Other values (52) | 219310 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 568295 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 63776 | 11.2% | |
| ' | 54893 | 9.7% |
| e | 38941 | 6.9% |
| o | 35016 | 6.2% |
| r | 29810 | 5.2% |
| a | 27114 | 4.8% |
| i | 26676 | 4.7% |
| n | 25652 | 4.5% |
| t | 23638 | 4.2% |
| , | 23469 | 4.1% |
| Other values (52) | 219310 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 568295 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 63776 | 11.2% | |
| ' | 54893 | 9.7% |
| e | 38941 | 6.9% |
| o | 35016 | 6.2% |
| r | 29810 | 5.2% |
| a | 27114 | 4.8% |
| i | 26676 | 4.7% |
| n | 25652 | 4.5% |
| t | 23638 | 4.2% |
| , | 23469 | 4.1% |
| Other values (52) | 219310 |
primary_category
Categorical
High correlation
| Distinct | 8 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 114.4 KiB |
| Skincare | |
|---|---|
| Makeup | |
| Hair | |
| Fragrance | |
| Bath & Body | |
| Other values (3) |
Length
| Max length | 15 |
|---|---|
| Median length | 11 |
| Mean length | 7.0894931 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Fragrance |
|---|---|
| 2nd row | Fragrance |
| 3rd row | Fragrance |
| 4th row | Fragrance |
| 5th row | Fragrance |
Common Values
| Value | Count | Frequency (%) |
| Skincare | 2224 | |
| Makeup | 1999 | |
| Hair | 1232 | |
| Fragrance | 1185 | |
| Bath & Body | 364 | 5.0% |
| Mini Size | 256 | 3.5% |
| Men | 57 | 0.8% |
| Tools & Brushes | 2 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| skincare | 2224 | |
| makeup | 1999 | |
| hair | 1232 | |
| fragrance | 1185 | |
| 366 | 4.4% | |
| bath | 364 | 4.4% |
| body | 364 | 4.4% |
| mini | 256 | 3.1% |
| size | 256 | 3.1% |
| men | 57 | 0.7% |
| Other values (2) | 4 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 8189 | |
| r | 5828 | |
| e | 5723 | |
| i | 4224 | |
| k | 4223 | |
| n | 3722 | 7.2% |
| c | 3409 | 6.6% |
| S | 2480 | 4.8% |
| M | 2312 | 4.5% |
| u | 2001 | 3.9% |
| Other values (16) | 9777 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 51888 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 8189 | |
| r | 5828 | |
| e | 5723 | |
| i | 4224 | |
| k | 4223 | |
| n | 3722 | 7.2% |
| c | 3409 | 6.6% |
| S | 2480 | 4.8% |
| M | 2312 | 4.5% |
| u | 2001 | 3.9% |
| Other values (16) | 9777 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 51888 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 8189 | |
| r | 5828 | |
| e | 5723 | |
| i | 4224 | |
| k | 4223 | |
| n | 3722 | 7.2% |
| c | 3409 | 6.6% |
| S | 2480 | 4.8% |
| M | 2312 | 4.5% |
| u | 2001 | 3.9% |
| Other values (16) | 9777 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 51888 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 8189 | |
| r | 5828 | |
| e | 5723 | |
| i | 4224 | |
| k | 4223 | |
| n | 3722 | 7.2% |
| c | 3409 | 6.6% |
| S | 2480 | 4.8% |
| M | 2312 | 4.5% |
| u | 2001 | 3.9% |
| Other values (16) | 9777 |
secondary_category
Categorical
High correlation
| Distinct | 39 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 114.4 KiB |
| Women | |
|---|---|
| Hair Styling & Treatments | |
| Eye | |
| Face | |
| Moisturizers | |
| Other values (34) |
Length
| Max length | 25 |
|---|---|
| Median length | 18 |
| Mean length | 10.467004 |
| Min length | 3 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Value & Gift Sets |
|---|---|
| 2nd row | Women |
| 3rd row | Women |
| 4th row | Women |
| 5th row | Women |
Common Values
| Value | Count | Frequency (%) |
| Women | 815 | |
| Hair Styling & Treatments | 729 | 10.0% |
| Eye | 650 | 8.9% |
| Face | 644 | 8.8% |
| Moisturizers | 526 | 7.2% |
| Treatments | 447 | 6.1% |
| Shampoo & Conditioner | 405 | 5.5% |
| Value & Gift Sets | 387 | 5.3% |
| Lip | 384 | 5.2% |
| Cleansers | 347 | 4.7% |
| Other values (29) | 1985 |
Length
| Value | Count | Frequency (%) |
| 1811 | 13.9% | |
| treatments | 1236 | 9.5% |
| eye | 832 | 6.4% |
| women | 815 | 6.3% |
| hair | 779 | 6.0% |
| moisturizers | 734 | 5.6% |
| styling | 729 | 5.6% |
| face | 644 | 5.0% |
| lip | 444 | 3.4% |
| conditioner | 405 | 3.1% |
| Other values (41) | 4568 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 9515 | 12.4% |
| 5678 | 7.4% | |
| t | 5390 | 7.0% |
| i | 5341 | 7.0% |
| n | 4993 | 6.5% |
| r | 4897 | 6.4% |
| a | 4873 | 6.4% |
| s | 4865 | 6.4% |
| o | 3747 | 4.9% |
| m | 2643 | 3.5% |
| Other values (31) | 24666 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 76608 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 9515 | 12.4% |
| 5678 | 7.4% | |
| t | 5390 | 7.0% |
| i | 5341 | 7.0% |
| n | 4993 | 6.5% |
| r | 4897 | 6.4% |
| a | 4873 | 6.4% |
| s | 4865 | 6.4% |
| o | 3747 | 4.9% |
| m | 2643 | 3.5% |
| Other values (31) | 24666 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 76608 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 9515 | 12.4% |
| 5678 | 7.4% | |
| t | 5390 | 7.0% |
| i | 5341 | 7.0% |
| n | 4993 | 6.5% |
| r | 4897 | 6.4% |
| a | 4873 | 6.4% |
| s | 4865 | 6.4% |
| o | 3747 | 4.9% |
| m | 2643 | 3.5% |
| Other values (31) | 24666 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 76608 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 9515 | 12.4% |
| 5678 | 7.4% | |
| t | 5390 | 7.0% |
| i | 5341 | 7.0% |
| n | 4993 | 6.5% |
| r | 4897 | 6.4% |
| a | 4873 | 6.4% |
| s | 4865 | 6.4% |
| o | 3747 | 4.9% |
| m | 2643 | 3.5% |
| Other values (31) | 24666 |
tertiary_category
Text
| Distinct | 107 |
|---|---|
| Distinct (%) | 1.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 114.4 KiB |
Length
| Max length | 26 |
|---|---|
| Median length | 23 |
| Mean length | 13.189917 |
| Min length | 5 |
Unique
| Unique | 5 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | Perfume Gift Sets |
|---|---|
| 2nd row | Perfume |
| 3rd row | Perfume |
| 4th row | Perfume |
| 5th row | Perfume |
| Value | Count | Frequency (%) |
| 1333 | 8.9% | |
| face | 1034 | 6.9% |
| no | 840 | 5.6% |
| sub-category | 840 | 5.6% |
| perfume | 632 | 4.2% |
| hair | 544 | 3.6% |
| body | 485 | 3.2% |
| moisturizers | 372 | 2.5% |
| serums | 365 | 2.4% |
| eye | 352 | 2.3% |
| Other values (121) | 8203 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 10168 | 10.5% |
| 7681 | 8.0% | |
| r | 7099 | 7.4% |
| a | 6568 | 6.8% |
| o | 6103 | 6.3% |
| s | 5940 | 6.2% |
| i | 4805 | 5.0% |
| t | 4787 | 5.0% |
| l | 3607 | 3.7% |
| n | 3279 | 3.4% |
| Other values (37) | 36500 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 96537 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 10168 | 10.5% |
| 7681 | 8.0% | |
| r | 7099 | 7.4% |
| a | 6568 | 6.8% |
| o | 6103 | 6.3% |
| s | 5940 | 6.2% |
| i | 4805 | 5.0% |
| t | 4787 | 5.0% |
| l | 3607 | 3.7% |
| n | 3279 | 3.4% |
| Other values (37) | 36500 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 96537 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 10168 | 10.5% |
| 7681 | 8.0% | |
| r | 7099 | 7.4% |
| a | 6568 | 6.8% |
| o | 6103 | 6.3% |
| s | 5940 | 6.2% |
| i | 4805 | 5.0% |
| t | 4787 | 5.0% |
| l | 3607 | 3.7% |
| n | 3279 | 3.4% |
| Other values (37) | 36500 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 96537 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 10168 | 10.5% |
| 7681 | 8.0% | |
| r | 7099 | 7.4% |
| a | 6568 | 6.8% |
| o | 6103 | 6.3% |
| s | 5940 | 6.2% |
| i | 4805 | 5.0% |
| t | 4787 | 5.0% |
| l | 3607 | 3.7% |
| n | 3279 | 3.4% |
| Other values (37) | 36500 |
child_count
Real number (ℝ)
Zeros
| Distinct | 55 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.7946441 |
| Minimum | 0 |
|---|---|
| Maximum | 105 |
| Zeros | 4758 |
| Zeros (%) | 65.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 114.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 9 |
| Maximum | 105 |
| Range | 105 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 5.6901687 |
|---|---|
| Coefficient of variation (CV) | 3.1706391 |
| Kurtosis | 53.416068 |
| Mean | 1.7946441 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 6.2518825 |
| Sum | 13135 |
| Variance | 32.37802 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 4758 | |
| 1 | 1072 | 14.6% |
| 2 | 457 | 6.2% |
| 3 | 239 | 3.3% |
| 5 | 127 | 1.7% |
| 4 | 124 | 1.7% |
| 7 | 72 | 1.0% |
| 9 | 50 | 0.7% |
| 6 | 49 | 0.7% |
| 11 | 37 | 0.5% |
| Other values (45) | 334 | 4.6% |
| Value | Count | Frequency (%) |
| 0 | 4758 | |
| 1 | 1072 | 14.6% |
| 2 | 457 | 6.2% |
| 3 | 239 | 3.3% |
| 4 | 124 | 1.7% |
| 5 | 127 | 1.7% |
| 6 | 49 | 0.7% |
| 7 | 72 | 1.0% |
| 8 | 35 | 0.5% |
| 9 | 50 | 0.7% |
| Value | Count | Frequency (%) |
| 105 | 1 | < 0.1% |
| 78 | 1 | < 0.1% |
| 73 | 2 | < 0.1% |
| 63 | 1 | < 0.1% |
| 59 | 2 | < 0.1% |
| 55 | 1 | < 0.1% |
| 51 | 1 | < 0.1% |
| 50 | 2 | < 0.1% |
| 49 | 8 | |
| 47 | 2 | < 0.1% |
Interactions
Correlations
| brand_id | child_count | limited_edition | loves_count | new | online_only | out_of_stock | price_usd | primary_category | rating | reviews | secondary_category | sephora_exclusive | variation_type | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| brand_id | 1.000 | -0.117 | 0.021 | -0.174 | 0.107 | 0.172 | 0.104 | -0.088 | 0.208 | -0.003 | -0.171 | 0.234 | 0.246 | 0.150 |
| child_count | -0.117 | 1.000 | 0.035 | 0.386 | 0.000 | 0.070 | 0.027 | 0.037 | 0.120 | 0.033 | 0.346 | 0.148 | 0.041 | 0.151 |
| limited_edition | 0.021 | 0.035 | 1.000 | 0.031 | 0.106 | 0.048 | 0.171 | 0.049 | 0.129 | 0.122 | 0.018 | 0.448 | 0.073 | 0.398 |
| loves_count | -0.174 | 0.386 | 0.031 | 1.000 | 0.023 | 0.094 | 0.026 | -0.149 | 0.061 | -0.058 | 0.700 | 0.053 | 0.041 | 0.070 |
| new | 0.107 | 0.000 | 0.106 | 0.023 | 1.000 | 0.012 | 0.000 | 0.032 | 0.026 | 0.186 | 0.016 | 0.100 | 0.074 | 0.055 |
| online_only | 0.172 | 0.070 | 0.048 | 0.094 | 0.012 | 1.000 | 0.000 | 0.087 | 0.190 | 0.131 | 0.077 | 0.217 | 0.084 | 0.139 |
| out_of_stock | 0.104 | 0.027 | 0.171 | 0.026 | 0.000 | 0.000 | 1.000 | 0.032 | 0.075 | 0.031 | 0.029 | 0.152 | 0.003 | 0.128 |
| price_usd | -0.088 | 0.037 | 0.049 | -0.149 | 0.032 | 0.087 | 0.032 | 1.000 | 0.213 | 0.180 | -0.036 | 0.259 | 0.144 | 0.201 |
| primary_category | 0.208 | 0.120 | 0.129 | 0.061 | 0.026 | 0.190 | 0.075 | 0.213 | 1.000 | 0.054 | 0.051 | 0.897 | 0.126 | 0.442 |
| rating | -0.003 | 0.033 | 0.122 | -0.058 | 0.186 | 0.131 | 0.031 | 0.180 | 0.054 | 1.000 | 0.114 | 0.103 | 0.000 | 0.061 |
| reviews | -0.171 | 0.346 | 0.018 | 0.700 | 0.016 | 0.077 | 0.029 | -0.036 | 0.051 | 0.114 | 1.000 | 0.060 | 0.019 | 0.041 |
| secondary_category | 0.234 | 0.148 | 0.448 | 0.053 | 0.100 | 0.217 | 0.152 | 0.259 | 0.897 | 0.103 | 0.060 | 1.000 | 0.167 | 0.558 |
| sephora_exclusive | 0.246 | 0.041 | 0.073 | 0.041 | 0.074 | 0.084 | 0.003 | 0.144 | 0.126 | 0.000 | 0.019 | 0.167 | 1.000 | 0.123 |
| variation_type | 0.150 | 0.151 | 0.398 | 0.070 | 0.055 | 0.139 | 0.128 | 0.201 | 0.442 | 0.061 | 0.041 | 0.558 | 0.123 | 1.000 |
Missing values
Sample
| product_id | product_name | brand_id | brand_name | loves_count | rating | reviews | size | variation_type | variation_value | ingredients | price_usd | limited_edition | new | online_only | out_of_stock | sephora_exclusive | highlights | primary_category | secondary_category | tertiary_category | child_count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | P473671 | Fragrance Discovery Set | 6342 | 19-69 | 6320 | 3.6364 | 11.0 | Unknown | Not Applicable | Unknown | ['Capri Eau de Parfum:', 'Alcohol Denat. (SD Alcohol 39C), Parfum (Fragrance) D-Limonene, Linalool, Benzyl Salicylate, Ethylhexyl Methoxycinnamate, Butyl Methoxydibenzoylmethane, Ethylhexyl Salicylate, Benzl Benzoate, Citral, Geraniol, Eugenol, Benzyl Alcohol, Farnesol, Citronellol, Isoeugenol.', 'Invisible Post Eau de Parfum:', 'Alcohol Denat. (SD Alcohol 39C), Parfum (Fragrance) Ethylhexyl Methoxycinnamate, Ethylhexyl Salicylate, Butyl Methoxydibenzoylmethane, Benzyl Benzoate, Citral, Coumarin, Limonene, Alpha-Isomethyl Ionone, Linalool.', 'Kashbah Eau de Parfum:', 'Alcohol Denat. (SD Alcohol 39C), Parfum (Fragrance) Coumarin, Ethylhexyl Methoxycinnamate, Butyl Methoxydibenzoylmethane, Ethylhexyl Salicylate, D-Limonene, Eugenol, Linalool, Citronellol, Geraniol, Cinnamal, Citral.', 'L’Air Barbes Eau de Parfum:', 'Alcohol Denat. (SD Alcohol 39C), Parfum (Fragrance) Benzyl Salicylate, D-Limonene, Ethylhexyl Methoxycinnamate, Butyl Methoxydibenzoylmethane, Ethylhexyl Salicylate, Linalool Citral, Alphaisomethyl Ionone, Benzyl Benzoate, Geraniol Farnesol, Isoeugenol, Eugenol.', 'La Habana Eau de Parfum:', 'Alcohol Denat. (SD Alcohol 39C), Parfum (Fragrance) Ethylhexyl Methoxycinnamate, Ethylhexyl Salicylate, Butyl Methoxydibenzoylmethane, Benzyl Alcohol, Benzyl Benzoate, Benzyl Cinnamate, Cinnamal, Citral, Coumarin Limonene, Eugenol, Alpha-Isomethyl Ionone, Linalool.', 'Purple Haze Eau de Parfum:', 'Alcohol Denat. (SD Alcohol 39C), Parfum (Fragrance) Octoxynol-10, D-Limonene, Ethylhexyl Methoxycinnamate, Butyl Methoxydibenzoylmethane, Ethylhexyl Salicylate, Geraniol, Linalool, Coumarin, Farnesol, Eugenol, Citral.', 'Rainbow Bar Eau de Parfum:', 'Alcohol Denat. (SD Alcohol 39C), Parfum (Fragrance) D-Limonene, Ethylhexyl Methoxycinnamate, Butyl Methoxydibenzoylmethane, Ethylhexyl Salicylate, Hexyl Cinnamal, Citronellol, Linalool, Coumarin, Eugenol, Citral, Isoeugenol, Geraniol.'] | 35.0 | 0 | 0 | 1 | 0 | 0 | ['Unisex/ Genderless Scent', 'Warm &Spicy Scent', 'Woody & Earthy Scent', 'Fresh Scent'] | Fragrance | Value & Gift Sets | Perfume Gift Sets | 0 |
| 1 | P473668 | La Habana Eau de Parfum | 6342 | 19-69 | 3827 | 4.1538 | 13.0 | 3.4 oz/ 100 mL | Size + Concentration + Formulation | 3.4 oz/ 100 mL | ['Alcohol Denat. (SD Alcohol 39C), Parfum (Fragrance) Ethylhexyl Methoxycinnamate, Ethylhexyl Salicylate, Butyl Methoxydibenzoylmethane, Benzyl Alcohol, Benzyl Benzoate, Benzyl Cinnamate, Cinnamal, Citral, Coumarin Limonene, Eugenol, Alpha-Isomethyl Ionone, Linalool.'] | 195.0 | 0 | 0 | 1 | 0 | 0 | ['Unisex/ Genderless Scent', 'Layerable Scent', 'Warm &Spicy Scent'] | Fragrance | Women | Perfume | 2 |
| 2 | P473662 | Rainbow Bar Eau de Parfum | 6342 | 19-69 | 3253 | 4.2500 | 16.0 | 3.4 oz/ 100 mL | Size + Concentration + Formulation | 3.4 oz/ 100 mL | ['Alcohol Denat. (SD Alcohol 39C), Parfum (Fragrance) D-Limonene, Ethylhexyl Methoxycinnamate, Butyl Methoxydibenzoylmethane, Ethylhexyl Salicylate, Hexyl Cinnamal Citronellol, Linalool, Coumarin, Eugenol, Citral, Isoeugenol, Geraniol.'] | 195.0 | 0 | 0 | 1 | 0 | 0 | ['Unisex/ Genderless Scent', 'Layerable Scent', 'Woody & Earthy Scent'] | Fragrance | Women | Perfume | 2 |
| 3 | P473660 | Kasbah Eau de Parfum | 6342 | 19-69 | 3018 | 4.4762 | 21.0 | 3.4 oz/ 100 mL | Size + Concentration + Formulation | 3.4 oz/ 100 mL | ['Alcohol Denat. (SD Alcohol 39C), Parfum (Fragrance) Coumarin, Ethylhexyl Methoxycinnamate, Butyl Methoxydibenzoylmethane, Ethylhexyl Salicylate, D-Limonene, Eugenol, Linalool, Citronellol, Geraniol, Cinnamal, Citral.'] | 195.0 | 0 | 0 | 1 | 0 | 0 | ['Unisex/ Genderless Scent', 'Layerable Scent', 'Warm &Spicy Scent'] | Fragrance | Women | Perfume | 2 |
| 4 | P473658 | Purple Haze Eau de Parfum | 6342 | 19-69 | 2691 | 3.2308 | 13.0 | 3.4 oz/ 100 mL | Size + Concentration + Formulation | 3.4 oz/ 100 mL | ['Alcohol Denat. (SD Alcohol 39C), Parfum (Fragrance) Octoxynol-10, D-Limonene, Ethylhexyl Methoxycinnamate, Butyl Methoxydibenzoylmethane, Ethylhexyl Salicylate, Geraniol, Linalool, Coumarin, Farnesol, Eugenol, Citral.'] | 195.0 | 0 | 0 | 1 | 0 | 0 | ['Unisex/ Genderless Scent', 'Layerable Scent', 'Woody & Earthy Scent'] | Fragrance | Women | Perfume | 2 |
| 5 | P473661 | Kasbah Eau de Parfum Travel Spray | 6342 | 19-69 | 2448 | 4.4762 | 21.0 | 0.25 oz/ 7.5 mL | Size + Concentration + Formulation | 0.25 oz/ 7.5 mL Eau de Parfum Spray | ['Alcohol Denat. (SD Alcohol 39C), Parfum (Fragrance) Coumarin, Ethylhexyl Methoxycinnamate,', 'Butyl Methoxydibenzoylmethane, Ethylhexyl Salicylate, D-Limonene, Eugenol, Linalool, Citronellol, Geraniol, Cinnamal, Citral.'] | 30.0 | 0 | 0 | 1 | 0 | 0 | ['Warm &Spicy Scent', 'Unisex/ Genderless Scent', 'Layerable Scent'] | Fragrance | Women | Rollerballs & Travel Size | 0 |
| 6 | P473659 | Purple Haze Eau de Parfum Travel Spray | 6342 | 19-69 | 1619 | 3.2308 | 13.0 | 0.25 oz/ 7.5 mL | Size + Concentration + Formulation | 0.25 oz/ 7.5 mL | ['Alcohol Denat. (SD Alcohol 39C), Parfum (Fragrance) Octoxynol-10, D-Limonene, Ethylhexyl Methoxycinnamate, Butyl Methoxydibenzoylmethane, Ethylhexyl Salicylate, Geraniol, Linalool, Coumarin, Farnesol, Eugenol, Citral.'] | 30.0 | 0 | 0 | 1 | 0 | 0 | ['Unisex/ Genderless Scent', 'Layerable Scent', 'Woody & Earthy Scent'] | Fragrance | Women | Rollerballs & Travel Size | 0 |
| 7 | P473666 | Invisible Post Eau de Parfum | 6342 | 19-69 | 1542 | 3.6250 | 8.0 | 3.4 oz/ 100 mL | Size + Concentration + Formulation | 3.4 oz/ 100 mL | ['Alcohol Denat. (SD Alcohol 39C), Parfum (Fragrance) Ethylhexyl Methoxycinnamate, Ethylhexyl Salicylate, Butyl Methoxydibenzoylmethane, Benzyl Benzoate, Citral, Coumarin, Limonene, Alpha-Isomethyl Ionone, Linalool.'] | 195.0 | 0 | 0 | 1 | 0 | 0 | ['Unisex/ Genderless Scent', 'allure 2022 Best of Beauty Award Winner', 'Fresh Scent'] | Fragrance | Women | Perfume | 2 |
| 8 | P472300 | Capri Eau de Parfum | 6342 | 19-69 | 1542 | 3.5714 | 7.0 | 3.4 oz/ 100 mL | Size + Concentration + Formulation | 3.4 oz/ 100 mL Eau de Parfum Spray | ['Alcohol Denat. (SD Alcohol 39C), Parfum (Fragrance) D-Limonene, Linalool, Benzyl Salicylate, Ethylhexyl Methoxycinnamate, Butyl Methoxydibenzoylmethane, Ethylhexyl Salicylate,', 'Benzl Benzoate, Citral, Geraniol, Eugenol, Benzyl Alcohol, Farnesol, Citronellol, Isoeugenol.'] | 195.0 | 0 | 0 | 1 | 0 | 0 | ['Fresh Scent', 'Layerable Scent', 'Unisex/ Genderless Scent'] | Fragrance | Women | Perfume | 2 |
| 9 | P473667 | Invisible Post Eau de Parfum Travel Spray | 6342 | 19-69 | 1377 | 3.6250 | 8.0 | 0.25 oz/ 7.5 mL | Size + Concentration + Formulation | 0.25 oz/ 7.5 mL | ['Alcohol Denat. (SD Alcohol 39C), Parfum (Fragrance) Ethylhexyl Methoxycinnamate, Ethylhexyl Salicylate, Butyl Methoxydibenzoylmethane, Benzyl Benzoate, Citral, Coumarin, Limonene, Alpha-Isomethyl Ionone, Linalool.'] | 30.0 | 0 | 0 | 1 | 0 | 0 | ['Unisex/ Genderless Scent', 'allure 2022 Best of Beauty Award Winner', 'Fresh Scent'] | Fragrance | Women | Rollerballs & Travel Size | 0 |
| product_id | product_name | brand_id | brand_name | loves_count | rating | reviews | size | variation_type | variation_value | ingredients | price_usd | limited_edition | new | online_only | out_of_stock | sephora_exclusive | highlights | primary_category | secondary_category | tertiary_category | child_count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8481 | P383083 | L’Homme Parfum Intense | 1070 | Yves Saint Laurent | 4369 | 4.5795 | 88.0 | 3.3 oz/ 100 mL | Size + Concentration + Formulation | 3.3 oz/ 100 mL Eau de Parfum Spray | ['Alcohol, Aqua / Water, Parfum / Fragrance, Benzyl Salicylate, Butyl Methoxydibenzoylmethane, Ethylhexyl Methoxycinnamate, Coumarin, Limonene, Benzyl Alcohol, Linalool, Alpha-Isomethyl Ionone, Geraniol, Methyl Anthranilate, Citral, Citronellol, Cinnamal, Ci 19140 / Yellow 5, Ci 14700 / Red 4, Ci 60730 / Ext. Violet 2, Ci 17200 / Red 33, Ci 42090 / Blue 1.'] | 110.0 | 0 | 0 | 0 | 1 | 0 | No Highlights | Fragrance | Men | Cologne | 0 |
| 8482 | P504333 | Black Opium Perfume Gift Set | 1070 | Yves Saint Laurent | 3844 | 5.0000 | 2.0 | Unknown | Not Applicable | Unknown | ['Alcohol, Water, Benzyl Salicylate, Benzyl Alcohol, Hydroxycitronellal, Butyl Methoxydibenzoylmethane, Hexyl Cinnamal, Limonene, Linalool, Geraniol, Citronellol, Cinnamyl Alcohol, Methyl Anthranilate, Amyl Cinnamal, Citral, Coumarin, Benzyl Benzoate, Ci 15985/Yellow 6, Ci 17200/Red 33.'] | 85.0 | 1 | 1 | 0 | 0 | 0 | No Highlights | Fragrance | Value & Gift Sets | Perfume Gift Sets | 0 |
| 8483 | P460446 | L'Homme Le Parfum | 1070 | Yves Saint Laurent | 3812 | 5.0000 | 6.0 | 3.3 oz/ 100 mL | Size + Concentration + Formulation | 3.3 oz/ 100 mL | ['Alcohol, Aqua / Water, Parfum / Fragrance, Limonene, Butyl Methoxydibenzoylmethane, Hydroxycitronellal, Linalool, Citronellol, Coumarin, Geraniol, Citral, Ci 60730 / Ext. Violet 2, Ci 19140 / Yellow 5, Ci 14700 / Red 4, Ci 42090 / Blue 1.'] | 148.0 | 0 | 0 | 0 | 0 | 0 | No Highlights | Fragrance | Men | Cologne | 1 |
| 8484 | P467660 | Mascara Volume Effet Faux Cils Radical | 1070 | Yves Saint Laurent | 3489 | 4.0192 | 104.0 | 0.25 oz/ 7.5 ml | Size | 0.25 oz/ 7.5 ml | ['Aqua/Water, Paraffin, Stearic Acid, Copernicia Cerifera Cera/Carnauba Wax, Palmitic Acid, C10-30 Cholesterol/Lanosterol Esters, Cera Alba/Beeswax, Triethanolamine, Nylon-12, Aminomethyl Propanol, Phenoxyethanol, Hydroxyethylcellulose, Candelilla Cera/Candelilla Wax, Laureth-21, Stearyl Stearate, Stearyl Palmitate, Vp/Eicosene Copolymer, Dimethicone, Myristic Acid Silica, Tocopheryl Acetate, Panthenol, Cetyl Palmitate, Peg-40 Hydrogenated Castor Oil, Cetyl Stearate, Methylparaben, Adipic Acid/Diglycol Crosspolymer, Sorbitan Stearate, Butylparaben, Peg-40 Stearate, Behenic Acid, Bht, Ethylparaben, Cera Microcristallina/Microcrystalline Wax, Argania Spinosa Kernel Oil, Ricinus Communis Seed Oil/Castor Seed Oil, Prunus Amygdalus Dulcis Oil/Sweet Almond Oil, Propylparaben, Carthamus Tinctorius Seed Oil/Safflower Seed Oil, Benzyl Alcohol, Sodium Dehydroacetate, Glycerin, Arachidic Acid, Tocopherol, Juglans Regia Leaf Extract/Walnut Leaf Extract, Parfum/Fragrance. [May Contain Ci 77499/Iron Oxides, Ci 77266 [Nano]/Black 2, Ci 77007/Ultramarines.]'] | 29.0 | 0 | 0 | 0 | 0 | 0 | No Highlights | Makeup | Eye | Mascara | 0 |
| 8486 | P457262 | Y Eau Fraiche | 1070 | Yves Saint Laurent | 3089 | 4.7333 | 150.0 | 3.4 oz/ 100 mL | Size + Concentration + Formulation | 3.4 oz/ 100 mL Spray | ['Alcohol, Parfum / Fragrance, Aqua / Water, Limonene, Linalool, Ethylhexyl Salicylate, Butyl Methoxydibenzoylmethane, Citral, Alpha-Isomethyl Ionone, Hexyl Cinnamal, Citronellol, Geraniol, Coumarin, Ci 60730 / Ext. Violet 2, Ci 42090 / Blue 1.'] | 99.0 | 0 | 0 | 0 | 1 | 0 | ['Fresh Scent', 'Layerable Scent'] | Fragrance | Men | Cologne | 0 |
| 8487 | P501330 | Black Opium Gift Set | 1070 | Yves Saint Laurent | 3086 | 3.5000 | 2.0 | Unknown | Not Applicable | Unknown | ['The Slim Velvet Radical:', 'Dimethicone, Bis-Diglyceryl Polyacyladipate-2, Hydrogenated Polyisobutene, Tridecyl Trimellitate, Phenyl Trimethicone, Isohexadecane, Hydrogenated Jojoba Oil, Dimethicone Crosspolymer, Isostearyl Isostearate, Paraffin, Ci 77492/Iron Oxides, Methylsilanol/Silicate Crosspolymer, Ci 77891/Titanium Dioxide, Cera Microcristallina/Microcrystalline Wax, Kaolin, Mica, Vinyl Dimethicone/Methicone Silsesquioxane Crosspolymer, Nylon-12, Polyethylene, Ci 77491/Iron Oxides, Synthetic Wax, Ci 15850/Red 7, Ci 77499/Iron Oxides, Triethoxysilylethyl Polydimethylsiloxyethyl Dimethicone, Isopropyl Titanium Triisostearate, Pentaerythrityl Tetra-Di-T-Butyl Hydroxyhydrocinnamate, Alumina, Benzyl Alcohol, Limonene, Aqua/Water, Propanediol, Benzyl Benzoate, Anise Alcohol, Tocopherol, Pelargonium Graveolens Extract, Parfum/Fragrance.', 'Black Opium Eau de Parfum:', 'Alcohol, Water, Benzyl Salicylate, Benzyl Alcohol, Hydroxycitronellal, Butyl Methoxydibenzoylmethane, Hexyl Cinnamal, Limonene, Linalool, Geraniol, Citronellol, Cinnamyl Alcohol, Methyl Anthranilate, Amyl Cinnamal, Citral, Coumarin, Benzyl Benzoate, Ci 15985/Yellow 6, Ci 17200/Red 33'] | 150.0 | 1 | 0 | 0 | 1 | 0 | No Highlights | Fragrance | Value & Gift Sets | Perfume Gift Sets | 0 |
| 8488 | P504430 | Libre Eau de Parfum Gift Set | 1070 | Yves Saint Laurent | 2864 | 5.0000 | 1.0 | Unknown | Not Applicable | Unknown | ['Libre Eau de Parfum:', 'Alcohol, Parfum/Fragrance, Aqua/Water, Limonene, Linalool, Benzyl Salicylate, Hydroxycitronellal, Benzyl Alcohol, Ethylhexyl Salicylate, Butyl Methoxydibenzoylmethane, Coumarin, Geraniol, Methyl Anthranilate, Citronellol, Citral, Isoeugenol, Alpha-Isomethyl Ionone, Farnesol, Ci 14700/Red 4, Ci 19140/Yellow 5, Ci 60730/Ext., Violet 2.', 'Body Lotion:', 'Aqua / Water / Eau , Glycerin , Propanediol , Cetyl Alcohol , Butyrospermum Parkii Butter / Shea Butter , Isopropyl Palmitate , Parfum / Fragrance , Prunus Amygdalus Dulcis Oil / Sweet Almond Oil , Myristyl Myristate , Zea Mays Starch / Corn Starch , Polyglyceryl-3 Methylglucose Distearate , Sodium Polyacrylate , Carbomer , Hydrogenated Starch Hydrolysate , Caprylyl Glycol , Benzoic Acid , Sodium Hydroxide , Linalool , Limonene , C12-13 Alkyl Lactate , Benzyl Alcohol , Benzyl Salicylate , Sodium Hyaluronate , Hydroxycitronellal , Coumarin , Geraniol , Citronellol , Lippia Citriodora Leaf Extract , Citral , Isoeugenol , Citric Acid'] | 148.0 | 1 | 1 | 1 | 1 | 0 | No Highlights | Fragrance | Value & Gift Sets | Perfume Gift Sets | 0 |
| 8489 | P467659 | Couture Clutch Eyeshadow Palette | 1070 | Yves Saint Laurent | 2790 | 4.4286 | 7.0 | Unknown | Not Applicable | Unknown | ['Talc, Synthetic Fluorphlogopite, Triethylhexanoin, Octyldodecyl Stearoyl Stearate, Ci 77891 / Titanium Dioxide, Caprylyl Glycol, Ci 77491, Ci 77499 / Iron Oxides, Dehydroacetic Acid, Phenoxyethanol, Caprylic/Capric Triglyceride, Hexylene Glycol, Punica Granatum Fruit Extract.'] | 150.0 | 0 | 0 | 0 | 0 | 0 | No Highlights | Makeup | Eye | Eye Palettes | 0 |
| 8490 | P500874 | L'Homme Eau de Parfum | 1070 | Yves Saint Laurent | 2319 | 4.6367 | 556.0 | 2 oz / 60 mL | Size + Concentration + Formulation | 2 oz / 60 mL eau de parfum spray | ['Alcohol, Aqua / Water / Eau, Parfum / Fragrance, Limonene, Linalool, Coumarin, Butyl Methoxydibenzoylmethane, Alpha-Isomethyl Ionone, Geraniol, Citral, Citronellol, Tris(Tetramethylhydroxypiperidinol) Citrate, Ci 15985 / Yellow 6, Cinnamal, Ci 14700 / Red 4, Isoeugenol, Eugenol, Ci 19140 / Yellow 5, Ci 42090 / Blue 1.'] | 106.0 | 0 | 0 | 0 | 0 | 0 | ['Layerable Scent', 'Woody & Earthy Scent'] | Fragrance | Men | Cologne | 1 |
| 8491 | P504428 | Mon Paris Eau de Parfum Gift Set | 1070 | Yves Saint Laurent | 1475 | 5.0000 | 2.0 | Unknown | Not Applicable | Unknown | ['Mon Paris Eau de Parfum:', 'Alcohol, Parfum/Fragrance, Aqua/Water, Benzyl Salicylate, Linalool, Benzyl Alcohol, Hydroxycitronellal, Ethylhexyl Methoxycinnamate, Limonene, Hexyl Cinnamal, Geraniol, Citronellol, Butyl Methoxydibenzoylmethane, Ethylhexyl Salicylate, Eugenol, Citral, Tris (Tetramethylhydroxypiperidinol) Citrate, Benzyl Benzoate, Farnesol, Bht, Ci 17200/Red 33, Ci 60730/Ext. Violet 2.', 'Body Lotion:', 'Aqua / Water , Glycerin , Propanediol , Isopropyl Palmitate , Alcohol Denat. , Parfum / Fragrance , Cetyl Alcohol , Myristyl Myristate , Olea Europaea Fruit Oil / Olive Fruit Oil , Zea Mays Starch / Corn Starch , Prunus Armeniaca Kernel Oil / Apricot Kernel Oil , Persea Gratissima Oil / Avocado Oil , Sodium Polyacrylate , Caprylyl Glycol , Carbomer , Benzyl Salicylate , Limnanthes Alba Seed Oil / Meadowfoam Seed Oil , Tocopheryl Acetate , Polyglyceryl-3 Methylglucose Distearate , Butyl Methoxydibenzoylmethane , Ethylhexyl Methoxycinnamate , Benzoic Acid , Benzyl Alcohol , Linalool , Sodium Hydroxide , C12-13 Alkyl Lactate , Tetrasodium Edta , Hydroxycitronellal , Citronellol , Geraniol , Limonene , Citral , Bht , Ci 17200 / Red 33'] | 134.0 | 1 | 1 | 1 | 1 | 0 | No Highlights | Fragrance | Value & Gift Sets | Perfume Gift Sets | 0 |